All Questions
Tagged with postgresqllinux
51 questions
0votes
1answer
159views
How to install Postgresql17 to my EC2 instance on Amazon Linux [duplicate]
I'm trying to install postgres version 17 on my EC2 instance on Amazon Linux but I get this error: [ec2-user@ip-172-31-8-1 ~]$ sudo dnf install -y postgresql17 postgresql17-server Last metadata ...
Samantha Chan
0votes
1answer
455views
system ID mismatch, node belongs to a different cluster
I have etcd cluster, and now trying to initialize patroni (on server A and server B), but whenever I try to do so I'm getting the error about cluster mismatch. Tried removing 'initialize' from etcd, ...
- 1
0votes
1answer
44views
How to escape symbols inside runuser command?
I want to get list of PostgreSQL databases. PostgreSQL works by postgres user, so I need to use runuser. While I'm execute runuser -l postgres -c 'psql -tc "SELECT datname FROM pg_database WHERE ...
- 127
0votes
1answer
318views
postgresql service down, "/run/postgresql/.s.PGSQL.5432" failed: No such file or directory
i on artix with runit postgresql have issues after starting #sudo sv start postgresql ok: run: postgresql: (pid 849) 1236s #sudo -u postgres psql psql: error: connection to server on socket "/run/...
0votes
1answer
1kviews
Trying to install postgresql16-client on an Alpine Docker Container
I'm trying to create a Docker container with postgresql16-client but i'm getting an error saying that the package does not exist. I'm going to also install dotnet 8 on this container in order to run ...
0votes
3answers
300views
Tracking the source of PostgreSQL authentication failures in Linux Localhost
I have these logs in my PostgreSQL database log file that appeared after I changed the database password. 2023-09-14 11:57:15.937 UTC [3401773] username@db-name FATAL: password authentication failed ...
0votes
0answers
46views
Ubuntu - PostegreSQL displays errors in foreign language even after changing all locales to en_US and reinstalling it
I inherited a Ubuntu desktop from another employee and installed PostgreSQL with the help of the official guide. abc@lenovo:~$ sudo apt install postgresql-15 I had not known that I had to setup an ...
-1votes
1answer
173views
[email protected] fails to load but not [email protected] - are both needed in linux boot?
[email protected] fails to load but not [email protected] - are both needed in linux boot? linux - bookworm sid. So [email protected] is needed ?
- 308
0votes
1answer
2kviews
-bash: psql: command not found after manual installation of PostgreSQL
I installed the PostgreSQL database via source code, and I successfully up it and installed the pg admin also. I am able to execute SQL functions via it. But when I type psql in the server I am having ...
- 11
0votes
1answer
115views
how to execute a command in a running command in bash
how to execute this commands in bash script #!/bin/bash docker exec -ti test psql db db drop schema if exists stack cascade; delete from partman.part_config; \q pwd cd /folder/name
- 3
0votes
1answer
3kviews
npm install failling at node-gyp rebuild and libpq
> [email protected] install /home/johnsoct/bobtail/node_modules/libpq > node-gyp rebuild /home/johnsoct/.nvm/versions/node/v12.22.4/lib/node_modules/npm/node_modules/npm-lifecycle/node-gyp-bin/node-...
0votes
0answers
64views
How to make sure two people are present when accessing a database on a server
My friends and I have a Mattermost instance up on a server through this set up. Mattermost does not support e2e encryption and we have a container with a Postgres database running that stores all of ...
1vote
1answer
7kviews
libicui18n.so.69 missing PostgreSQL ArchLinux
Problem: I tried to install PostgreSQL following the tutorial from the ArchWiki. As the postgres user, when running the following command: [postgres]$ initdb -D /var/lib/postgres/data I get the ...
- 121
1vote
0answers
782views
How can I learn why kswapd has very low page reclaim efficiency?
Problem/context I have a (managed) Postgres 10.16 instance running on Fedora 32 in a systemd-nspawn container. Periodically, I see a big spike in "system" CPU usage in our metrics, ...
- 111
1vote
1answer
2kviews
How to install postgresq 13 in Linux Mint 20.1
Following official instructions here https://www.postgresql.org/download/linux/debian/ but each time it still installs posgresql 12
